package com.czc.cca.ddl;

import org.zoomdev.zoom.dao.ddl.SqlType;
import org.zoomdev.zoom.dao.ddl._DDL_Column;
import org.zoomdev.zoom.dao.ddl._DDL_CompoundPrimary;
import org.zoomdev.zoom.dao.ddl._DDL_Table;
import org.zoomdev.zoom.dao.driver.mysql.MysqlDriver;

@_DDL_CompoundPrimary(columns = {"mer_id", "account"})
@_DDL_Table(name = "c_device_id", simpleName = "", engine = MysqlDriver.InnoDB, comment = "设备号码闲置表")
public class _DDL_CDeviceId {

    @_DDL_Column(name = "mer_id", type = SqlType.BIGINT_UNSIGNED, nullable = false, comment = "商户id")
    private java.math.BigInteger merId;

    @_DDL_Column(name = "account", type = SqlType.VARCHAR, size = 30, nullable = false, comment = "后台登录id")
    private String account;

    @_DDL_Column(name = "id", type = SqlType.INT_UNSIGNED, comment = "闲置的id，每一个商户在绑定设备的时候只能有一个")
    private Long id;

    @_DDL_Column(name = "cr_time", type = SqlType.TIMESTAMP, defaultFunction = MysqlDriver.CURRENT_TIMESTAMP, comment = "创建时间")
    private java.sql.Timestamp crTime;

}
